/*
 Navicat Premium Data Transfer

 Source Server         : MySQL
 Source Server Type    : MySQL
 Source Server Version : 80021
 Source Host           : localhost:3306
 Source Schema         : flask_web

 Target Server Type    : MySQL
 Target Server Version : 80021
 File Encoding         : 65001

 Date: 23/09/2020 09:45:30
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for epidemic
-- ----------------------------
DROP TABLE IF EXISTS `epidemic`;
CREATE TABLE `epidemic` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `nowConfirm` int DEFAULT NULL,
  `confirm` int DEFAULT NULL,
  `suspect` int DEFAULT NULL,
  `dead` int DEFAULT NULL,
  `showRate` varchar(255) DEFAULT NULL,
  `heal` int DEFAULT NULL,
  `deadRate` decimal(10,2) DEFAULT NULL,
  `healRate` decimal(10,2) DEFAULT NULL,
  `showHeal` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of epidemic
-- ----------------------------
BEGIN;
INSERT INTO `epidemic` VALUES (1, '云南', 11, 209, 0, 2, 'false', 196, 0.96, 93.78, 'true');
INSERT INTO `epidemic` VALUES (2, '内蒙古', 3, 263, 0, 1, 'false', 259, 0.38, 98.48, 'true');
INSERT INTO `epidemic` VALUES (3, '北京', 0, 935, 0, 9, 'false', 926, 0.96, 99.04, 'true');
INSERT INTO `epidemic` VALUES (4, '台湾', 23, 509, 0, 7, 'false', 479, 1.38, 94.11, 'true');
INSERT INTO `epidemic` VALUES (5, '吉林', 0, 157, 0, 2, 'false', 155, 1.27, 98.73, 'true');
INSERT INTO `epidemic` VALUES (6, '四川', 15, 672, 0, 3, 'false', 654, 0.45, 97.32, 'true');
INSERT INTO `epidemic` VALUES (7, '天津', 7, 238, 0, 3, 'false', 228, 1.26, 95.80, 'true');
INSERT INTO `epidemic` VALUES (8, '宁夏', 0, 75, 0, 0, 'false', 75, 0.00, 100.00, 'true');
INSERT INTO `epidemic` VALUES (9, '安徽', 0, 991, 0, 6, 'false', 985, 0.61, 99.39, 'true');
INSERT INTO `epidemic` VALUES (10, '山东', 8, 831, 0, 7, 'false', 816, 0.84, 98.19, 'true');
INSERT INTO `epidemic` VALUES (11, '山西', 0, 203, 0, 0, 'false', 203, 0.00, 100.00, 'true');
INSERT INTO `epidemic` VALUES (12, '广东', 21, 1803, 0, 8, 'false', 1774, 0.44, 98.39, 'true');
INSERT INTO `epidemic` VALUES (13, '广西', 2, 258, 0, 2, 'false', 254, 0.78, 98.45, 'true');
INSERT INTO `epidemic` VALUES (14, '新疆', 0, 902, 0, 3, 'false', 899, 0.33, 99.67, 'true');
INSERT INTO `epidemic` VALUES (15, '江苏', 1, 665, 0, 0, 'false', 664, 0.00, 99.85, 'true');
INSERT INTO `epidemic` VALUES (16, '江西', 0, 935, 0, 1, 'false', 934, 0.11, 99.89, 'true');
INSERT INTO `epidemic` VALUES (17, '河北', 2, 365, 0, 6, 'false', 357, 1.64, 97.81, 'true');
INSERT INTO `epidemic` VALUES (18, '河南', 3, 1279, 0, 22, 'false', 1254, 1.72, 98.05, 'true');
INSERT INTO `epidemic` VALUES (19, '浙江', 9, 1282, 0, 1, 'false', 1272, 0.08, 99.22, 'true');
INSERT INTO `epidemic` VALUES (20, '海南', 0, 171, 0, 6, 'false', 165, 3.51, 96.49, 'true');
INSERT INTO `epidemic` VALUES (21, '湖北', 0, 68139, 0, 4512, 'false', 63627, 6.62, 93.38, 'true');
INSERT INTO `epidemic` VALUES (22, '湖南', 0, 1019, 0, 4, 'false', 1015, 0.39, 99.61, 'true');
INSERT INTO `epidemic` VALUES (23, '澳门', 0, 46, 0, 0, 'false', 46, 0.00, 100.00, 'true');
INSERT INTO `epidemic` VALUES (24, '甘肃', 0, 170, 0, 2, 'false', 168, 1.18, 98.82, 'true');
INSERT INTO `epidemic` VALUES (25, '福建', 15, 396, 0, 1, 'false', 380, 0.25, 95.96, 'true');
INSERT INTO `epidemic` VALUES (26, '西藏', 0, 1, 0, 0, 'false', 1, 0.00, 100.00, 'true');
INSERT INTO `epidemic` VALUES (27, '贵州', 0, 147, 0, 2, 'false', 145, 1.36, 98.64, 'true');
INSERT INTO `epidemic` VALUES (28, '辽宁', 1, 265, 0, 2, 'false', 262, 0.75, 98.87, 'true');
INSERT INTO `epidemic` VALUES (29, '重庆', 0, 584, 0, 6, 'false', 578, 1.03, 98.97, 'true');
INSERT INTO `epidemic` VALUES (30, '陕西', 26, 401, 0, 3, 'false', 372, 0.75, 92.77, 'true');
INSERT INTO `epidemic` VALUES (31, '青海', 0, 18, 0, 0, 'false', 18, 0.00, 100.00, 'true');
INSERT INTO `epidemic` VALUES (32, '香港', 226, 5046, 0, 103, 'false', 4717, 2.04, 93.48, 'true');
INSERT INTO `epidemic` VALUES (33, '黑龙江', 0, 948, 0, 13, 'false', 935, 1.37, 98.63, 'true');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
